[dbo].[BAEOrderAttributeLoadValues]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderAttributeLoadValues

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@OrderAttributeID	int	4

SQL Script

create procedure [dbo].[BAEOrderAttributeLoadValues] @OrderAttributeID as
int
AS
    SELECT ospav.Title AS 'Value' FROM OrderSuperProductAttribute AS ospa
    JOIN OrderSuperProductAttributeValue AS ospav
    ON ospa.OrderSuperProductAttributeID = ospav.OrderSuperProductAttributeID
    WHERE ospa.OrderSuperProductAttributeID = @OrderAttributeID ORDER BY ospav.SortOrder

GO

Uses

[dbo].[OrderSuperProductAttribute]
[dbo].[OrderSuperProductAttributeValue]
dbo